﻿using System;

namespace App.Domain
{
    public static class DbObject
    {
        /// <summary>
        /// Contains the Names of the Stored Procedures
        /// </summary>
        public static class SP
        {
            public const String GET_PAGED_PRODUCTS_BY_COMPANY = "dbo.GetPagedProductsByCompany";
            public const String GET_PAGED_PRODUCTS_BY_CATEGORY = "dbo.GetPagedProductsByCategory";
            public const String GET_CONTACTS_BY_COMPANY = "dbo.GetContactsByCompany";
            public const String GET_USERS_BY_COMPANY = "dbo.GetUsersByCompany";
            public const String GET_PRODUCT_RANDOMLY = "dbo.GetPagedRandomProduct";
            public const String GET_PRODUCT_BY_SEARCH = "dbo.GetPagedProductBySearch";
            public const String GET_PRODUCT_POPULAR_SEARCH = "dbo.GetPagedProductByPopularSearch";
            public const String GET_PRODUCT_FROM_WISH_LIST = "GetPagedProductsFromWishList";
            //public const String GET_PRODUCT_BY_LATEST_ADDED = "dbo.GetProductByLatestAdded";

            //public const String GET_PRODUCT_BY_LATEST_UPDATED = "dbo.GetProductByLatestUpdated";
            public const String GET_PRODUCT_BY_DISCOUNT_PRODUCTS = "dbo.GetPagedProductByDiscount";
            public const String GET_PRODUCT_BY_SPECIAL_OFFERS = "dbo.GetPagedProductBySpecialOffers";

            public const String GET_CONTENT = "dbo.GetContentList";
            public const String GET_CATEGORY = "dbo.GetCategoryList";
            public const String GET_TOP_VIEWED_PRODUCTS = "dbo.GetTopViewedProducts";
            public const String GET_RECENT_PRODUCTS = "dbo.GetRecentProducts";
            public const String GET_SIMILAR_PRODUCTS = "dbo.GetSimilarProducts";

            public const String GET_STORE_DETAILS = "dbo.GetStoreDetails";
            public const String GET_PRODUCTS_BY_ID = "dbo.GetProductsByID";
            public const String GET_LOOKUP_DATA = "dbo.GetLookupData";

            public const String GET_RECEIVE_DETAILS = "dbo.GetReceiveDetails";
            public const String GET_ISSUE_DETAILS = "dbo.GetIssueDetails";
            public const String GET_INVENTORY_LIST = "dbo.GetPagedInventory";
            
        }
        public static class Sql
        {
            public const String INDUSTRY_TYPE = "SELECT * FROM IndustryType ORDER BY Name";
        }
        /// <summary>
        /// Contains the Names of the Database Functions
        /// </summary>
        public static class Function
        {
            
        }
        
        /// <summary>
        /// Conntains the Names of the Database Views
        /// </summary>
        public static class View
        {

        }
    }
}
